Pandas Profile _BPIC2017_O

Dataset statistics

Number of variables	26
Number of observations	1198366
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	237.7 MiB
Average record size in memory	208.0 B

Variable types

Categorical	12
Numeric	13
DateTime	1

Warnings

`case:ApplicationType` has constant value "other"	Constant
`Action` has constant value "other"	Constant
`EventOrigin` has constant value "other"	Constant
`lifecycle:transition` has constant value "other"	Constant
`Accepted` has constant value "other"	Constant
`Selected` has constant value "other"	Constant
`case:concept:name` has a high cardinality: 31413 distinct values	High cardinality
`org:resource` has a high cardinality: 139 distinct values	High cardinality
`CreditScore` has a high cardinality: 512 distinct values	High cardinality
`timesincemidnight` is highly correlated with `hour`	High correlation
`hour` is highly correlated with `timesincemidnight`	High correlation
`Action` is highly correlated with `Accepted` and 7 other fields	High correlation
`Accepted` is highly correlated with `Action` and 7 other fields	High correlation
`Selected` is highly correlated with `Action` and 7 other fields	High correlation
`lifecycle:transition` is highly correlated with `Action` and 7 other fields	High correlation
`label` is highly correlated with `Action` and 5 other fields	High correlation
`concept:name` is highly correlated with `Action` and 5 other fields	High correlation
`case:ApplicationType` is highly correlated with `Action` and 7 other fields	High correlation
`EventOrigin` is highly correlated with `Action` and 7 other fields	High correlation
`case:LoanGoal` is highly correlated with `Action` and 5 other fields	High correlation
`case:RequestedAmount` has 112679 (9.4%) zeros	Zeros
`FirstWithdrawalAmount` has 529089 (44.2%) zeros	Zeros
`MonthlyCost` has 276879 (23.1%) zeros	Zeros
`NumberOfTerms` has 276879 (23.1%) zeros	Zeros
`OfferedAmount` has 276879 (23.1%) zeros	Zeros
`timesincelastevent` has 31413 (2.6%) zeros	Zeros
`timesincecasestart` has 31413 (2.6%) zeros	Zeros
`weekday` has 247992 (20.7%) zeros	Zeros

Reproduction

Analysis started	2021-03-23 08:06:02.370719
Analysis finished	2021-03-23 08:10:19.219438
Duration	4 minutes and 16.85 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

case:ApplicationType
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

case:LoanGoal
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1184456
Boat	7223
Tax payments	5557
Business goal	1090
Debt restructuring	40

Length

Max length	18
Median length	5
Mean length	5.034143158
Min length	4

Characters and Unicode

Total characters	6032746
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1184456	98.8%
Boat	7223	0.6%
Tax payments	5557	0.5%
Business goal	1090	0.1%
Debt restructuring	40	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1184456	98.3%
boat	7223	0.6%
tax	5557	0.5%
payments	5557	0.5%
goal	1090	0.1%
business	1090	0.1%
debt	40	< 0.1%
restructuring	40	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
t	1197356	19.8%
o	1192769	19.8%
e	1191183	19.7%
r	1184576	19.6%
h	1184456	19.6%
a	19427	0.3%
s	8867	0.1%
B	8313	0.1%
	6687	0.1%
n	6687	0.1%
Other values (12)	32425	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6012149	99.7%
Uppercase Letter	13910	0.2%
Space Separator	6687	0.1%

Most frequent character per category

Value	Count	Frequency (%)
t	1197356	19.9%
o	1192769	19.8%
e	1191183	19.8%
r	1184576	19.7%
h	1184456	19.7%
a	19427	0.3%
s	8867	0.1%
n	6687	0.1%
x	5557	0.1%
p	5557	0.1%
Other values (8)	15714	0.3%

Value	Count	Frequency (%)
B	8313	59.8%
T	5557	39.9%
D	40	0.3%

Value	Count	Frequency (%)
	6687	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6026059	99.9%
Common	6687	0.1%

Most frequent character per script

Value	Count	Frequency (%)
t	1197356	19.9%
o	1192769	19.8%
e	1191183	19.8%
r	1184576	19.7%
h	1184456	19.7%
a	19427	0.3%
s	8867	0.1%
B	8313	0.1%
n	6687	0.1%
T	5557	0.1%
Other values (11)	26868	0.4%

Value	Count	Frequency (%)
	6687	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6032746	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	1197356	19.8%
o	1192769	19.8%
e	1191183	19.7%
r	1184576	19.6%
h	1184456	19.6%
a	19427	0.3%
s	8867	0.1%
B	8313	0.1%
	6687	0.1%
n	6687	0.1%
Other values (12)	32425	0.5%

case:RequestedAmount
Real number (ℝ_≥0)

ZEROS

Distinct	699
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16738.48355
Minimum	0
Maximum	450000
Zeros	112679
Zeros (%)	9.4%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6000
median	14000
Q3	23000
95-th percentile	48500
Maximum	450000
Range	450000
Interquartile range (IQR)	17000

Descriptive statistics

Standard deviation	15706.86017
Coefficient of variation (CV)	0.9383681697
Kurtosis	71.0810713
Mean	16738.48355
Median Absolute Deviation (MAD)	8000
Skewness	4.473249054
Sum	2.005882957 × 10¹⁰
Variance	246705456.4
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	152603	12.7%
15000	134636	11.2%
10000	113865	9.5%
0	112679	9.4%
25000	68605	5.7%
20000	65648	5.5%
30000	39684	3.3%
6000	32120	2.7%
50000	23967	2.0%
7000	23207	1.9%
Other values (689)	431352	36.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	112679	9.4%
600	40	< 0.1%
1000	65	< 0.1%
1600	39	< 0.1%
3000	103	< 0.1%

Value	Count	Frequency (%)
450000	46	< 0.1%
400000	61	< 0.1%
350000	43	< 0.1%
340000	29	< 0.1%
300000	87	< 0.1%

case:concept:name
Categorical

HIGH CARDINALITY

Distinct	31413
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

Application_2037628374	180
Application_1219772874	180
Application_1359726788	159
Application_1875888758	156
Application_1387439149	154
Other values (31408)	1197537

Length

Max length	22
Median length	22
Mean length	21.4898687
Min length	17

Characters and Unicode

Total characters	25752728
Distinct characters	20
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Application_652823628
2nd row	Application_652823628
3rd row	Application_652823628
4th row	Application_652823628
5th row	Application_652823628

Value	Count	Frequency (%)
Application_2037628374	180	< 0.1%
Application_1219772874	180	< 0.1%
Application_1359726788	159	< 0.1%
Application_1875888758	156	< 0.1%
Application_1387439149	154	< 0.1%
Application_1031629108	150	< 0.1%
Application_1681194502	149	< 0.1%
Application_984284284	148	< 0.1%
Application_2068346638	148	< 0.1%
Application_561182430	147	< 0.1%
Other values (31403)	1196795	99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
application_2037628374	180	< 0.1%
application_1219772874	180	< 0.1%
application_1359726788	159	< 0.1%
application_1875888758	156	< 0.1%
application_1387439149	154	< 0.1%
application_1031629108	150	< 0.1%
application_1681194502	149	< 0.1%
application_2068346638	148	< 0.1%
application_984284284	148	< 0.1%
application_561182430	147	< 0.1%
Other values (31403)	1196795	99.9%

Most occurring characters

Value	Count	Frequency (%)
p	2396732	9.3%
i	2396732	9.3%
1	1653530	6.4%
A	1198366	4.7%
l	1198366	4.7%
c	1198366	4.7%
a	1198366	4.7%
t	1198366	4.7%
o	1198366	4.7%
n	1198366	4.7%
Other values (10)	10917172	42.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11983660	46.5%
Decimal Number	11372336	44.2%
Uppercase Letter	1198366	4.7%
Connector Punctuation	1198366	4.7%

Most frequent character per category

Value	Count	Frequency (%)
1	1653530	14.5%
2	1154766	10.2%
0	1083388	9.5%
5	1075222	9.5%
4	1071431	9.4%
3	1070680	9.4%
6	1069037	9.4%
9	1068311	9.4%
7	1066032	9.4%
8	1059939	9.3%

Value	Count	Frequency (%)
p	2396732	20.0%
i	2396732	20.0%
l	1198366	10.0%
c	1198366	10.0%
a	1198366	10.0%
t	1198366	10.0%
o	1198366	10.0%
n	1198366	10.0%

Value	Count	Frequency (%)
A	1198366	100.0%

Value	Count	Frequency (%)
_	1198366	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13182026	51.2%
Common	12570702	48.8%

Most frequent character per script

Value	Count	Frequency (%)
1	1653530	13.2%
_	1198366	9.5%
2	1154766	9.2%
0	1083388	8.6%
5	1075222	8.6%
4	1071431	8.5%
3	1070680	8.5%
6	1069037	8.5%
9	1068311	8.5%
7	1066032	8.5%

Value	Count	Frequency (%)
p	2396732	18.2%
i	2396732	18.2%
A	1198366	9.1%
l	1198366	9.1%
c	1198366	9.1%
a	1198366	9.1%
t	1198366	9.1%
o	1198366	9.1%
n	1198366	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25752728	100.0%

Most frequent character per block

Value	Count	Frequency (%)
p	2396732	9.3%
i	2396732	9.3%
1	1653530	6.4%
A	1198366	4.7%
l	1198366	4.7%
c	1198366	4.7%
a	1198366	4.7%
t	1198366	4.7%
o	1198366	4.7%
n	1198366	4.7%
Other values (10)	10917172	42.4%

label
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

regular	1053868
deviant	144498

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	8388562
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	regular
2nd row	regular
3rd row	regular
4th row	regular
5th row	regular

Value	Count	Frequency (%)
regular	1053868	87.9%
deviant	144498	12.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
regular	1053868	87.9%
deviant	144498	12.1%

Most occurring characters

Value	Count	Frequency (%)
r	2107736	25.1%
e	1198366	14.3%
a	1198366	14.3%
g	1053868	12.6%
u	1053868	12.6%
l	1053868	12.6%
d	144498	1.7%
v	144498	1.7%
i	144498	1.7%
n	144498	1.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8388562	100.0%

Most frequent character per category

Value	Count	Frequency (%)
r	2107736	25.1%
e	1198366	14.3%
a	1198366	14.3%
g	1053868	12.6%
u	1053868	12.6%
l	1053868	12.6%
d	144498	1.7%
v	144498	1.7%
i	144498	1.7%
n	144498	1.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8388562	100.0%

Most frequent character per script

Value	Count	Frequency (%)
r	2107736	25.1%
e	1198366	14.3%
a	1198366	14.3%
g	1053868	12.6%
u	1053868	12.6%
l	1053868	12.6%
d	144498	1.7%
v	144498	1.7%
i	144498	1.7%
n	144498	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8388562	100.0%

Most frequent character per block

Value	Count	Frequency (%)
r	2107736	25.1%
e	1198366	14.3%
a	1198366	14.3%
g	1053868	12.6%
u	1053868	12.6%
l	1053868	12.6%
d	144498	1.7%
v	144498	1.7%
i	144498	1.7%
n	144498	1.7%

concept:name
Categorical

HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

W_Validate application	209110
W_Call after offers	190556
W_Call incomplete files	167689
W_Complete application	148178
W_Handle leads	47070
Other values (21)	435763

Length

Max length	26
Median length	20
Mean length	17.9697438
Min length	8

Characters and Unicode

Total characters	21534330
Distinct characters	35
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A_Create Application
2nd row	A_Submitted
3rd row	W_Handle leads
4th row	W_Handle leads
5th row	W_Complete application

Value	Count	Frequency (%)
W_Validate application	209110	17.4%
W_Call after offers	190556	15.9%
W_Call incomplete files	167689	14.0%
W_Complete application	148178	12.4%
W_Handle leads	47070	3.9%
O_Created	42819	3.6%
O_Create Offer	42819	3.6%
O_Sent (mail and online)	39550	3.3%
A_Validating	38726	3.2%
A_Create Application	31413	2.6%
Other values (16)	240436	20.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
application	388701	15.4%
w_call	358245	14.2%
w_validate	209110	8.3%
after	190556	7.6%
offers	190556	7.6%
incomplete	167689	6.6%
files	167689	6.6%
w_complete	148178	5.9%
w_handle	47070	1.9%
leads	47070	1.9%
Other values (30)	608094	24.1%

Most occurring characters

Value	Count	Frequency (%)
e	2251934	10.5%
l	2134309	9.9%
a	2118686	9.8%
i	1525314	7.1%
t	1506857	7.0%
	1324830	6.2%
p	1231077	5.7%
_	1198366	5.6%
o	1028421	4.8%
n	959413	4.5%
Other values (25)	6255123	29.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16457032	76.4%
Uppercase Letter	2470986	11.5%
Space Separator	1324830	6.2%
Connector Punctuation	1198366	5.6%
Open Punctuation	41558	0.2%
Close Punctuation	41558	0.2%

Most frequent character per category

Value	Count	Frequency (%)
e	2251934	13.7%
l	2134309	13.0%
a	2118686	12.9%
i	1525314	9.3%
t	1506857	9.2%
p	1231077	7.5%
o	1028421	6.2%
n	959413	5.8%
f	832972	5.1%
c	739660	4.5%
Other values (9)	2128389	12.9%

Value	Count	Frequency (%)
W	766145	31.0%
C	717478	29.0%
A	322288	13.0%
V	247836	10.0%
O	236088	9.6%
S	62137	2.5%
H	47070	1.9%
R	27951	1.1%
I	22968	0.9%
P	17250	0.7%
Other values (2)	3775	0.2%

Value	Count	Frequency (%)
_	1198366	100.0%

Value	Count	Frequency (%)
	1324830	100.0%

Value	Count	Frequency (%)
(	41558	100.0%

Value	Count	Frequency (%)
)	41558	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18928018	87.9%
Common	2606312	12.1%

Most frequent character per script

Value	Count	Frequency (%)
e	2251934	11.9%
l	2134309	11.3%
a	2118686	11.2%
i	1525314	8.1%
t	1506857	8.0%
p	1231077	6.5%
o	1028421	5.4%
n	959413	5.1%
f	832972	4.4%
W	766145	4.0%
Other values (21)	4572890	24.2%

Value	Count	Frequency (%)
	1324830	50.8%
_	1198366	46.0%
(	41558	1.6%
)	41558	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21534330	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	2251934	10.5%
l	2134309	9.9%
a	2118686	9.8%
i	1525314	7.1%
t	1506857	7.0%
	1324830	6.2%
p	1231077	5.7%
_	1198366	5.6%
o	1028421	4.8%
n	959413	4.5%
Other values (25)	6255123	29.0%

org:resource
Categorical

HIGH CARDINALITY

Distinct	139
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	342974
User_27	18795
User_121	18714
User_28	18348
User_68	17532
Other values (134)	782003

Length

Max length	8
Median length	7
Mean length	6.607720012
Min length	5

Characters and Unicode

Total characters	7918467
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	342974	28.6%
User_27	18795	1.6%
User_121	18714	1.6%
User_28	18348	1.5%
User_68	17532	1.5%
User_116	17423	1.5%
User_10	16348	1.4%
User_113	16142	1.3%
User_118	16005	1.3%
User_75	15920	1.3%
Other values (129)	700165	58.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	342974	28.6%
user_27	18795	1.6%
user_121	18714	1.6%
user_28	18348	1.5%
user_68	17532	1.5%
user_116	17423	1.5%
user_10	16348	1.4%
user_113	16142	1.3%
user_118	16005	1.3%
user_75	15920	1.3%
Other values (129)	700165	58.4%

Most occurring characters

Value	Count	Frequency (%)
e	1198366	15.1%
r	1198366	15.1%
U	855392	10.8%
s	855392	10.8%
_	855392	10.8%
1	542902	6.9%
o	342974	4.3%
t	342974	4.3%
h	342974	4.3%
2	224512	2.8%
Other values (8)	1159223	14.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4281046	54.1%
Decimal Number	1926637	24.3%
Uppercase Letter	855392	10.8%
Connector Punctuation	855392	10.8%

Most frequent character per category

Value	Count	Frequency (%)
1	542902	28.2%
2	224512	11.7%
3	195875	10.2%
4	164707	8.5%
6	162194	8.4%
5	135595	7.0%
7	135150	7.0%
8	129068	6.7%
9	123606	6.4%
0	113028	5.9%

Value	Count	Frequency (%)
e	1198366	28.0%
r	1198366	28.0%
s	855392	20.0%
o	342974	8.0%
t	342974	8.0%
h	342974	8.0%

Value	Count	Frequency (%)
U	855392	100.0%

Value	Count	Frequency (%)
_	855392	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5136438	64.9%
Common	2782029	35.1%

Most frequent character per script

Value	Count	Frequency (%)
_	855392	30.7%
1	542902	19.5%
2	224512	8.1%
3	195875	7.0%
4	164707	5.9%
6	162194	5.8%
5	135595	4.9%
7	135150	4.9%
8	129068	4.6%
9	123606	4.4%

Value	Count	Frequency (%)
e	1198366	23.3%
r	1198366	23.3%
U	855392	16.7%
s	855392	16.7%
o	342974	6.7%
t	342974	6.7%
h	342974	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7918467	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1198366	15.1%
r	1198366	15.1%
U	855392	10.8%
s	855392	10.8%
_	855392	10.8%
1	542902	6.9%
o	342974	4.3%
t	342974	4.3%
h	342974	4.3%
2	224512	2.8%
Other values (8)	1159223	14.6%

Action
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

CreditScore
Categorical

HIGH CARDINALITY

Distinct	512
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	748094
892.0	2611
923.0	2593
917.0	2590
931.0	2588
Other values (507)	439890

Length

Max length	6
Median length	5
Mean length	5.055664129
Min length	5

Characters and Unicode

Total characters	6058536
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	748094	62.4%
892.0	2611	0.2%
923.0	2593	0.2%
917.0	2590	0.2%
931.0	2588	0.2%
970.0	2577	0.2%
1004.0	2557	0.2%
878.0	2552	0.2%
977.0	2506	0.2%
965.0	2465	0.2%
Other values (502)	427233	35.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	748094	62.4%
892.0	2611	0.2%
923.0	2593	0.2%
917.0	2590	0.2%
931.0	2588	0.2%
970.0	2577	0.2%
1004.0	2557	0.2%
878.0	2552	0.2%
977.0	2506	0.2%
965.0	2465	0.2%
Other values (502)	427233	35.7%

Most occurring characters

Value	Count	Frequency (%)
o	748094	12.3%
t	748094	12.3%
h	748094	12.3%
e	748094	12.3%
r	748094	12.3%
0	603960	10.0%
.	450272	7.4%
9	242478	4.0%
8	235135	3.9%
1	163442	2.7%
Other values (6)	622779	10.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3740470	61.7%
Decimal Number	1867794	30.8%
Other Punctuation	450272	7.4%

Most frequent character per category

Value	Count	Frequency (%)
0	603960	32.3%
9	242478	13.0%
8	235135	12.6%
1	163442	8.8%
7	156499	8.4%
6	109776	5.9%
5	93423	5.0%
2	90981	4.9%
4	86459	4.6%
3	85641	4.6%

Value	Count	Frequency (%)
o	748094	20.0%
t	748094	20.0%
h	748094	20.0%
e	748094	20.0%
r	748094	20.0%

Value	Count	Frequency (%)
.	450272	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3740470	61.7%
Common	2318066	38.3%

Most frequent character per script

Value	Count	Frequency (%)
0	603960	26.1%
.	450272	19.4%
9	242478	10.5%
8	235135	10.1%
1	163442	7.1%
7	156499	6.8%
6	109776	4.7%
5	93423	4.0%
2	90981	3.9%
4	86459	3.7%

Value	Count	Frequency (%)
o	748094	20.0%
t	748094	20.0%
h	748094	20.0%
e	748094	20.0%
r	748094	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6058536	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	748094	12.3%
t	748094	12.3%
h	748094	12.3%
e	748094	12.3%
r	748094	12.3%
0	603960	10.0%
.	450272	7.4%
9	242478	4.0%
8	235135	3.9%
1	163442	2.7%
Other values (6)	622779	10.3%

EventOrigin
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

lifecycle:transition
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Accepted
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Selected
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

other	1198366

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5991830
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	other
3rd row	other
4th row	other
5th row	other

Value	Count	Frequency (%)
other	1198366	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	1198366	100.0%

Most occurring characters

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5991830	100.0%

Most frequent character per category

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5991830	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5991830	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	1198366	20.0%
t	1198366	20.0%
h	1198366	20.0%
e	1198366	20.0%
r	1198366	20.0%

FirstWithdrawalAmount
Real number (ℝ_≥0)

ZEROS

Distinct	5912
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6402.526992
Minimum	0
Maximum	75000
Zeros	529089
Zeros (%)	44.2%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1736
Q3	10000
95-th percentile	25000
Maximum	75000
Range	75000
Interquartile range (IQR)	10000

Descriptive statistics

Standard deviation	9966.585767
Coefficient of variation (CV)	1.556664389
Kurtosis	9.874908774
Mean	6402.526992
Median Absolute Deviation (MAD)	1736
Skewness	2.653209548
Sum	7672570662
Variance	99332831.85
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	529089	44.2%
5000	75912	6.3%
10000	56243	4.7%
15000	52943	4.4%
20000	21362	1.8%
25000	19886	1.7%
6000	17820	1.5%
7000	13209	1.1%
8000	11491	1.0%
30000	10249	0.9%
Other values (5902)	390162	32.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	529089	44.2%
0.25	54	< 0.1%
0.65	38	< 0.1%
1	248	< 0.1%
2	178	< 0.1%

Value	Count	Frequency (%)
75000	2683	0.2%
74400	20	< 0.1%
74000	38	< 0.1%
72500	13	< 0.1%
72000	21	< 0.1%

MonthlyCost
Real number (ℝ_≥0)

ZEROS

Distinct	5801
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	217.5205774
Minimum	0
Maximum	6673.83
Zeros	276879
Zeros (%)	23.1%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	70
median	198.41
Q3	300.07
95-th percentile	580.39
Maximum	6673.83
Range	6673.83
Interquartile range (IQR)	230.07

Descriptive statistics

Standard deviation	203.5212063
Coefficient of variation (CV)	0.9356411645
Kurtosis	9.850388796
Mean	217.5205774
Median Absolute Deviation (MAD)	107.06
Skewness	1.877629216
Sum	260669264.3
Variance	41420.88143
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	276879	23.1%
200	36167	3.0%
150	33283	2.8%
100	32973	2.8%
300	30930	2.6%
250	26524	2.2%
500	17980	1.5%
154.11	15114	1.3%
254.56	14105	1.2%
97.4	13430	1.1%
Other values (5791)	700981	58.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	276879	23.1%
43.05	78	< 0.1%
46.49	38	< 0.1%
48.28	2	< 0.1%
50	8138	0.7%

Value	Count	Frequency (%)
6673.83	2	< 0.1%
4000	8	< 0.1%
3380.09	3	< 0.1%
3260.92	26	< 0.1%
3173.49	2	< 0.1%

NumberOfTerms
Real number (ℝ_≥0)

ZEROS

Distinct	148
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	65.07475429
Minimum	0
Maximum	180
Zeros	276879
Zeros (%)	23.1%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	24
median	60
Q3	120
95-th percentile	127
Maximum	180
Range	180
Interquartile range (IQR)	96

Descriptive statistics

Standard deviation	48.02464497
Coefficient of variation (CV)	0.7379919524
Kurtosis	-1.218295923
Mean	65.07475429
Median Absolute Deviation (MAD)	60
Skewness	0.0406635905
Sum	77983373
Variance	2306.366525
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	276879	23.1%
120	189453	15.8%
60	86464	7.2%
126	56529	4.7%
127	38739	3.2%
36	31235	2.6%
58	30477	2.5%
56	27396	2.3%
48	26249	2.2%
72	20781	1.7%
Other values (138)	414164	34.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	276879	23.1%
5	8	< 0.1%
6	501	< 0.1%
7	274	< 0.1%
8	172	< 0.1%

Value	Count	Frequency (%)
180	10725	0.9%
177	52	< 0.1%
174	54	< 0.1%
170	23	< 0.1%
168	60	< 0.1%

OfferedAmount
Real number (ℝ_≥0)

ZEROS

Distinct	661
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	14605.49841
Minimum	0
Maximum	75000
Zeros	276879
Zeros (%)	23.1%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5000
median	10000
Q3	20000
95-th percentile	45000
Maximum	75000
Range	75000
Interquartile range (IQR)	15000

Descriptive statistics

Standard deviation	14594.45273
Coefficient of variation (CV)	0.9992437314
Kurtosis	2.569365706
Mean	14605.49841
Median Absolute Deviation (MAD)	10000
Skewness	1.483061985
Sum	1.750273271 × 10¹⁰
Variance	212998050.5
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	276879	23.1%
15000	109140	9.1%
5000	105096	8.8%
10000	93972	7.8%
25000	55440	4.6%
20000	50382	4.2%
30000	29649	2.5%
6000	24766	2.1%
7000	18781	1.6%
50000	18266	1.5%
Other values (651)	415995	34.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	276879	23.1%
5000	105096	8.8%
5050	15	< 0.1%
5065	13	< 0.1%
5100	443	< 0.1%

Value	Count	Frequency (%)
75000	8496	0.7%
74500	90	< 0.1%
74400	20	< 0.1%
74000	163	< 0.1%
73000	243	< 0.1%

timesincelastevent
Real number (ℝ_≥0)

ZEROS

Distinct	445568
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	825.8073586
Minimum	0
Maximum	196021.2644
Zeros	31413
Zeros (%)	2.6%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	3.333333333 × 10⁵
Q1	0.0001166666667
median	0.08578333333
Q3	4.3419375
95-th percentile	5387.60955
Maximum	196021.2644
Range	196021.2644
Interquartile range (IQR)	4.341820833

Descriptive statistics

Standard deviation	3881.657239
Coefficient of variation (CV)	4.700439151
Kurtosis	89.40859525
Mean	825.8073586
Median Absolute Deviation (MAD)	0.08578333333
Skewness	8.148425403
Sum	989619461.1
Variance	15067262.92
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.333333333 × 10⁵	81181	6.8%
5 × 10⁵	53497	4.5%
0.0001	34637	2.9%
0	31413	2.6%
8.333333333 × 10⁵	31013	2.6%
6.666666667 × 10⁵	29629	2.5%
0.0001166666667	26055	2.2%
1.666666667 × 10⁵	21265	1.8%
0.0001333333333	21050	1.8%
0.00015	14560	1.2%
Other values (445558)	854066	71.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	31413	2.6%
1.666666667 × 10⁵	21265	1.8%
3.333333333 × 10⁵	81181	6.8%
5 × 10⁵	53497	4.5%
6.666666667 × 10⁵	29629	2.5%

Value	Count	Frequency (%)
196021.2644	1	< 0.1%
192096.7863	1	< 0.1%
173283.6517	1	< 0.1%
161098.2429	1	< 0.1%
159861.5123	1	< 0.1%

timesincecasestart
Real number (ℝ_≥0)

ZEROS

Distinct	1075030
Distinct (%)	89.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12992.11481
Minimum	0
Maximum	411944.3109
Zeros	31413
Zeros (%)	2.6%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0005
Q1	563.6688958
median	7544.901358
Q3	19544.95185
95-th percentile	45795.37874
Maximum	411944.3109
Range	411944.3109
Interquartile range (IQR)	18981.28296

Descriptive statistics

Standard deviation	16463.6533
Coefficient of variation (CV)	1.267203495
Kurtosis	11.76958602
Mean	12992.11481
Median Absolute Deviation (MAD)	7536.426792
Skewness	2.409570598
Sum	1.556930866 × 10¹⁰
Variance	271051880
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	31413	2.6%
0.0001833333333	2096	0.2%
0.0001666666667	2064	0.2%
0.00015	2036	0.2%
0.0002	1992	0.2%
0.0002166666667	1964	0.2%
0.0002333333333	1842	0.2%
0.0001333333333	1705	0.1%
0.00025	1634	0.1%
0.0002666666667	1473	0.1%
Other values (1075020)	1150147	96.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	31413	2.6%
1.666666667 × 10⁵	4	< 0.1%
3.333333333 × 10⁵	988	0.1%
5 × 10⁵	993	0.1%
6.666666667 × 10⁵	453	< 0.1%

Value	Count	Frequency (%)
411944.3109	1	< 0.1%
411944.0787	1	< 0.1%
374237.6998	1	< 0.1%
374237.5756	1	< 0.1%
301075.3941	1	< 0.1%

timesincemidnight
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1399
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	719.9357992
Minimum	0
Maximum	1439
Zeros	5
Zeros (%)	< 0.1%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	410
Q1	547
median	699
Q3	863
95-th percentile	1125
Maximum	1439
Range	1439
Interquartile range (IQR)	316

Descriptive statistics

Standard deviation	219.8649576
Coefficient of variation (CV)	0.305395228
Kurtosis	-0.3363177717
Mean	719.9357992
Median Absolute Deviation (MAD)	158
Skewness	0.4441248625
Sum	862746584
Variance	48340.59957
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
360	12854	1.1%
420	9784	0.8%
392	3687	0.3%
391	2800	0.2%
581	2406	0.2%
586	2384	0.2%
575	2366	0.2%
593	2365	0.2%
577	2355	0.2%
574	2354	0.2%
Other values (1389)	1155011	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	12	< 0.1%
2	15	< 0.1%
3	9	< 0.1%
4	12	< 0.1%

Value	Count	Frequency (%)
1439	9	< 0.1%
1438	18	< 0.1%
1437	9	< 0.1%
1436	6	< 0.1%
1435	12	< 0.1%

event_nr
Real number (ℝ_≥0)

Distinct	180
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.22978789
Minimum	1
Maximum	180
Zeros	0
Zeros (%)	0.0%
Memory size	9.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	20
Q3	32
95-th percentile	56
Maximum	180
Range	179
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	17.48966015
Coefficient of variation (CV)	0.75289797
Kurtosis	2.825736343
Mean	23.22978789
Median Absolute Deviation (MAD)	11
Skewness	1.338395423
Sum	27837788
Variance	305.8882121
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	31413	2.6%
10	31413	2.6%
8	31413	2.6%
7	31413	2.6%
6	31413	2.6%
5	31413	2.6%
4	31413	2.6%
1	31413	2.6%
9	31413	2.6%
3	31413	2.6%
Other values (170)	884236	73.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	31413	2.6%
2	31413	2.6%
3	31413	2.6%
4	31413	2.6%
5	31413	2.6%

Value	Count	Frequency (%)
180	2	< 0.1%
179	2	< 0.1%
178	2	< 0.1%
177	2	< 0.1%
176	2	< 0.1%

month
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.764276523
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	9.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.357888527
Coefficient of variation (CV)	0.496415029
Kurtosis	-1.140259463
Mean	6.764276523
Median Absolute Deviation (MAD)	3
Skewness	-0.1346554955
Sum	8106079
Variance	11.27541536
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	118526	9.9%
9	114592	9.6%
8	113052	9.4%
10	111447	9.3%
11	104647	8.7%
6	104304	8.7%
3	95614	8.0%
12	95059	7.9%
2	89008	7.4%
5	85468	7.1%
Other values (2)	166649	13.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	83420	7.0%
2	89008	7.4%
3	95614	8.0%
4	83229	6.9%
5	85468	7.1%

Value	Count	Frequency (%)
12	95059	7.9%
11	104647	8.7%
10	111447	9.3%
9	114592	9.6%
8	113052	9.4%

weekday
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.169756151
Minimum	0
Maximum	6
Zeros	247992
Zeros (%)	20.7%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.643621876
Coefficient of variation (CV)	0.7575145601
Kurtosis	-0.9627978018
Mean	2.169756151
Median Absolute Deviation (MAD)	1
Skewness	0.2666852414
Sum	2600162
Variance	2.701492872
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	247992	20.7%
1	225767	18.8%
2	222589	18.6%
4	202066	16.9%
3	199665	16.7%
5	79764	6.7%
6	20523	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	247992	20.7%
1	225767	18.8%
2	222589	18.6%
3	199665	16.7%
4	202066	16.9%

Value	Count	Frequency (%)
6	20523	1.7%
5	79764	6.7%
4	202066	16.9%
3	199665	16.7%
2	222589	18.6%

hour
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.51548609
Minimum	0
Maximum	23
Zeros	563
Zeros (%)	< 0.1%
Memory size	9.1 MiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	9
median	11
Q3	14
95-th percentile	18
Maximum	23
Range	23
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.655485823
Coefficient of variation (CV)	0.3174408614
Kurtosis	-0.3079468253
Mean	11.51548609
Median Absolute Deviation (MAD)	3
Skewness	0.4625088554
Sum	13799767
Variance	13.3625766
Monotocity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
9	132898	11.1%
8	122804	10.2%
10	115891	9.7%
13	114499	9.6%
12	108674	9.1%
14	102702	8.6%
11	100521	8.4%
7	93896	7.8%
15	65110	5.4%
6	52049	4.3%
Other values (14)	189322	15.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	563	< 0.1%
1	333	< 0.1%
2	308	< 0.1%
3	332	< 0.1%
4	978	0.1%

Value	Count	Frequency (%)
23	2553	0.2%
22	4573	0.4%
21	5130	0.4%
20	8593	0.7%
19	27052	2.3%

open_cases
Real number (ℝ_≥0)

Distinct	2706
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1880.303421
Minimum	1
Maximum	2706
Zeros	0
Zeros (%)	0.0%
Memory size	9.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1199
Q1	1587
median	1904
Q3	2243
95-th percentile	2406
Maximum	2706
Range	2705
Interquartile range (IQR)	656

Descriptive statistics

Standard deviation	419.7365614
Coefficient of variation (CV)	0.2232281007
Kurtosis	1.29463494
Mean	1880.303421
Median Absolute Deviation (MAD)	326
Skewness	-0.8834269665
Sum	2253291690
Variance	176178.781
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1805	3355	0.3%
2324	3002	0.3%
1652	2918	0.2%
1539	2827	0.2%
2248	2809	0.2%
1803	2784	0.2%
1807	2678	0.2%
2250	2663	0.2%
1543	2654	0.2%
1542	2602	0.2%
Other values (2696)	1170074	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	< 0.1%
2	6	< 0.1%
3	6	< 0.1%
4	3	< 0.1%
5	6	< 0.1%

Value	Count	Frequency (%)
2706	6	< 0.1%
2705	7	< 0.1%
2704	9	< 0.1%
2703	10	< 0.1%
2702	10	< 0.1%

time:timestamp
Date

Distinct	1198309
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

Minimum	2016-01-01 09:51:15.304000+00:00
Maximum	2017-02-01 10:46:32.732000+00:00

Histogram

Histogram with fixed size bins (bins=50)

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	case:ApplicationType	case:LoanGoal	case:RequestedAmount	case:concept:name	label	concept:name	org:resource	Action	CreditScore	EventOrigin	lifecycle:transition	Accepted	Selected	FirstWithdrawalAmount	MonthlyCost	NumberOfTerms	OfferedAmount	timesincelastevent	timesincecasestart	timesincemidnight	event_nr	month	weekday	hour	open_cases	time:timestamp
0	other	other	20000.0	Application_652823628	regular	A_Create Application	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	0.000000	0.000000	591.0	1.0	1.0	4.0	9.0	1.0	2016-01-01 09:51:15.304000+00:00
1	other	other	20000.0	Application_652823628	regular	A_Submitted	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	0.000800	0.000800	591.0	2.0	1.0	4.0	9.0	1.0	2016-01-01 09:51:15.352000+00:00
2	other	other	20000.0	Application_652823628	regular	W_Handle leads	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	0.007033	0.007833	591.0	3.0	1.0	4.0	9.0	1.0	2016-01-01 09:51:15.774000+00:00
3	other	other	20000.0	Application_652823628	regular	W_Handle leads	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	1.343633	1.351467	592.0	4.0	1.0	4.0	9.0	1.0	2016-01-01 09:52:36.392000+00:00
4	other	other	20000.0	Application_652823628	regular	W_Complete application	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	0.000183	1.351650	592.0	5.0	1.0	4.0	9.0	1.0	2016-01-01 09:52:36.403000+00:00
5	other	other	20000.0	Application_652823628	regular	A_Concept	other	other	other	other	other	other	other	0.0	0.00	0.0	0.0	0.000167	1.351817	592.0	6.0	1.0	4.0	9.0	1.0	2016-01-01 09:52:36.413000+00:00
6	other	other	20000.0	Application_652823628	regular	W_Complete application	User_17	other	other	other	other	other	other	0.0	0.00	0.0	0.0	1492.766933	1494.118750	645.0	7.0	1.0	5.0	10.0	31.0	2016-01-02 10:45:22.429000+00:00
7	other	other	20000.0	Application_652823628	regular	W_Complete application	User_17	other	other	other	other	other	other	0.0	0.00	0.0	0.0	4.106450	1498.225200	649.0	8.0	1.0	5.0	10.0	31.0	2016-01-02 10:49:28.816000+00:00
8	other	other	20000.0	Application_652823628	regular	A_Accepted	User_52	other	other	other	other	other	other	0.0	0.00	0.0	0.0	33.591383	1531.816583	683.0	9.0	1.0	5.0	11.0	33.0	2016-01-02 11:23:04.299000+00:00
9	other	other	20000.0	Application_652823628	regular	O_Create Offer	User_52	other	other	other	other	other	other	20000.0	498.29	44.0	20000.0	5.994917	1537.811500	689.0	10.0	1.0	5.0	11.0	35.0	2016-01-02 11:29:03.994000+00:00

Last rows

	case:ApplicationType	case:LoanGoal	case:RequestedAmount	case:concept:name	label	concept:name	org:resource	Action	CreditScore	EventOrigin	lifecycle:transition	Accepted	Selected	FirstWithdrawalAmount	MonthlyCost	NumberOfTerms	OfferedAmount	timesincelastevent	timesincecasestart	timesincemidnight	event_nr	month	weekday	hour	open_cases	time:timestamp
1198356	other	other	20000.0	Application_1350494635	regular	W_Complete application	User_96	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000200	2749.454150	1167.0	12.0	1.0	0.0	19.0	1419.0	2017-01-02 19:27:20.465000+00:00
1198357	other	other	20000.0	Application_1350494635	regular	W_Call after offers	User_96	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000100	2749.454250	1167.0	13.0	1.0	0.0	19.0	1419.0	2017-01-02 19:27:20.471000+00:00
1198358	other	other	20000.0	Application_1350494635	regular	W_Call after offers	User_96	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000017	2749.454267	1167.0	14.0	1.0	0.0	19.0	1419.0	2017-01-02 19:27:20.472000+00:00
1198359	other	other	20000.0	Application_1350494635	regular	A_Complete	User_96	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000033	2749.454300	1167.0	15.0	1.0	0.0	19.0	1419.0	2017-01-02 19:27:20.474000+00:00
1198360	other	other	20000.0	Application_1350494635	regular	W_Call after offers	User_96	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	2.091917	2751.546217	1169.0	16.0	1.0	0.0	19.0	1419.0	2017-01-02 19:29:25.989000+00:00
1198361	other	other	20000.0	Application_1350494635	regular	W_Call after offers	other	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	4983.603717	7735.149933	393.0	17.0	1.0	4.0	6.0	1142.0	2017-01-06 06:33:02.212000+00:00
1198362	other	other	20000.0	Application_1350494635	regular	W_Call after offers	other	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000150	7735.150083	393.0	18.0	1.0	4.0	6.0	1142.0	2017-01-06 06:33:02.221000+00:00
1198363	other	other	20000.0	Application_1350494635	regular	A_Cancelled	User_28	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	14598.314883	22333.464967	591.0	19.0	1.0	0.0	9.0	594.0	2017-01-16 09:51:21.114000+00:00
1198364	other	other	20000.0	Application_1350494635	regular	O_Cancelled	User_28	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000417	22333.465383	591.0	20.0	1.0	0.0	9.0	594.0	2017-01-16 09:51:21.139000+00:00
1198365	other	other	20000.0	Application_1350494635	regular	W_Call after offers	User_28	other	other	other	other	other	other	20000.0	297.81	77.0	20000.0	0.000117	22333.465500	591.0	21.0	1.0	0.0	9.0	593.0	2017-01-16 09:51:21.146000+00:00

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters